The List filtered documents in dropdown advanced 2.0 AS component

List two independent xml-fields in a dropdown input-control, data is fetched from an ept-category and can be filtered on up to ten XML fields.

When to use

This component is typically used in an EPT edit template when the user should be able to select a field value from a another category. Often this second category is used to implement a one-to-many-relation between the categories. This makes it possible to use EPT as a simple relational database.

Field name

Name/id

The name and id of the dropdown. This must be unique per page.

List start options

Use blank start

Specifies wheter to make the first selection in the dropdown blank (without value). The idea with this option is to supply a text in the dropdown that tells the user to select something, if something isn't already selected.

BlankStartText

Specifies the text to display for the initial "blank start", this parameter is only used when the Use blank start parameter is checked.

List settings

Field to fill in the dropdown

The name of an EPT field that you want to use for caption in the dropdown-options.

Data type

The data type for field to fill in the dropdown. Must be specified for correct sorting.

WARNING you must be sure that all values in this ept field corresponds to the chosen data type.

Value field

Optional the field that you want to use as value in dropdown-options, if this parameter is empty, the document id from each ept document will be used as value.

Selected value

Specifies a value that should be selected, if an option with this value exists, the option is selected.

Appearance and behaviors

ClassName

Optional, a   value that specifies the class attribute for the dropdown control. This can be used if you want to apply styling to the dropdown.

Attributes

Optional, a value that contains HTML attributes for the dropdown control.

Size

Specifies the size, in number of entries, of the dropdown control. A value higher than 1 renders a multi-select list box rather than a regular drowdown control.

MultiSelect

Allow multiple selections, can only be used if Size is set to more then 1.

Xml index settings

Number

Specifies the maximum number of documents you want to list. Use zero (0) to list all documents that correspond to the filter criteria.

XMLField3

Optional, the name of an extra EPT field to filter on.

XMLField4

Optional, the name of an extra EPT field to filter on.

XMLField5

Optional, the name of an extra EPT field to filter on.

XMLField6

Optional, the name of an extra EPT field to filter on.

XMLField7

Optional, the name of an extra EPT field to filter on.

XMLField8

Optional, the name of an extra EPT field to filter on.

XMLField9

Optional, the name of an extra EPT field to filter on.

XMLField10

Optional, the name of an extra EPT field to filter on.

FilterCriteria

Optional, a filter criteria.

This filter criteria is the WHERE part of a regular SQL query. You can use any of the fields you have specfied as a xmlfield (field to fill in the dropdown, value field or xmlfield3-10) but their names must be enclosed with []. Since the underlying data is stored in Xml all field names are case sensitive.

For example:

[Country] = 'Sweden'

([Age] > '18' AND [Sex] = 'F') OR ([Age] > '20' AND [Sex] = 'M')

SortDesc

Specifies whether to change from the default acending sort order to descending sort order.

Listing options

Specify one of the follwing options.

• List approved documents
  List approved documents. Only browse permission is required.
• List drafts
  List drafts only. Read permission is required.
• List drafts or approved documents
  List drafts or approved documents if no draft vas found. Read permission is required.

Check for read permission

Specifies whether the component should check for read permission instead of browse permission. This value should be true when drafts are requested in the Listing options.

Check security

Specifies whether to check meta data security for the field specified in the Field to fill in the dropdown parameter.

Cache methods

Cache options

Specify one of the follwing options.

• No cache
  Do not cache the xml query.
• Use application cache
  Cache the result from the xml query using application variables. This option should not be used at an intranet with security permissions set for the xml query items.
  WARNING there are security problems with this parameter. See the Remarks section for more information.

Application cache timeout

A value that specifies the timeout in minutes for the application cache. Use zero (0) to cache indefinitly or until the Web site is restarted. 

Security Warning
If the component cache method is set to Use application cache, and the xml query items contain security permissions which might differ among visitors, a potential security problem exists. If a user that has high level access visits the page where this component resides and the result is cached, a user with restricted access that visits the page at a later time might be able to get hold of information which should be inaccessible to him/her.